IF NOT EXISTS (select * from dbo.syscolumns where id = object_id(N'[dbo].[ContentTypes]') AND Name = 'IsSupportedLogicalDeletion' )
	ALTER TABLE [dbo].ContentTypes ADD [IsSupportedLogicalDeletion] bit not null default(0)
go

IF NOT EXISTS (select * from dbo.syscolumns where id = object_id(N'[dbo].[ContentTypes]') AND Name = 'IsSupportedRevisions' )
	ALTER TABLE [dbo].ContentTypes ADD [IsSupportedRevisions] bit not null default(1)
go

IF NOT EXISTS (select * from dbo.syscolumns where id = object_id(N'[dbo].[ContentTypes]') AND Name = 'IsSupportedWorkflow' )
	ALTER TABLE [dbo].ContentTypes ADD [IsSupportedWorkflow] bit not null default(0)
go

IF NOT EXISTS (select * from dbo.syscolumns where id = object_id(N'[dbo].[ContentTypes]') AND Name = 'IsSummaryEditable' )
	ALTER TABLE [dbo].ContentTypes ADD [IsSummaryEditable] bit not null default(1)
go

IF NOT EXISTS (select * from dbo.syscolumns where id = object_id(N'[dbo].[ContentTypes]') AND Name = 'IsBodyEditable' )
	ALTER TABLE [dbo].ContentTypes ADD [IsBodyEditable] bit not null default(1)
go

IF NOT EXISTS (select * from dbo.syscolumns where id = object_id(N'[dbo].[ContentTypes]') AND Name = 'DefaultSortOrder' )
	ALTER TABLE [dbo].ContentTypes ADD [DefaultSortOrder] nvarchar(255) null
go